2016-07-29 - 27589 - Break Fix - Update MSRP file in DSSCO reports #SalesDistribution
Service Request
27589 - Update MSRP file in DSSCO reports
Problem Summary
Currency field needs to be added in ECC infosets ZSD_SOFMIGOPOS too in addition to ZSD_SOFOPENPOS.
Admin Info
Purpose
|
Currency field needs to be added in ECC infosets ZSD_SOFMIGOPOS too in addition to ZSD_SOFOPENPOS.
|
Requested by
|
Lafsolt Cheung
|
Issue Date
|
07-29-2016
|
Resolved by
|
Naveen Gadde
|
Resolved Date
|
08-01-2016
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Bhumi Shah on 07-14-2016:
PO download data for DSSCO is pulling incorrect amount for Japan POs as there should be no decimal in the currency. Repository function is available to convert the amount for Japanese and Korean currencies however the ECC query is missing currency key. Currency key needs to be added to ECC query ZSD_SOFMIGOPOS too in addition to ZSD_SOFOPENPOS. Query is based on sales order tables so I am assuming currency key should be available. Can you please let me know who can assist from your team?
Solution Analysis and Recommendations
Along with infosets ZSD_SOFMIGOPOS & ZSD_SOFOPENPOS, corresponding infoset queries are also needed to be updated with the Currency key.
Resolution
1. Need to update infosets ZSD_SOFMIGOPOS & ZSD_SOFOPENPOS with the currency key.
2. Need to update infoset queries ZSD_SOFMIGOPOS & ZSD_SOFOPENPOS with the currency key.
3. Need to validate the changes in NEQ100, before moving to production NEP.
Release Information
2016-08-01 - 27589 - Rel Notes - Update MSRP file in DSSCO reports
PO download data for DSSCO is pulling incorrect amount for Japan POs as there should be no decimal in the currency. Repository function is available to convert the amount for Japanese and Korean currencies however the ECC query is missing currency key.
Currency key needs to be added to an ECC query SOFOPENPOS. Query is based on sales order tables so I am assuming currency key should be available. Can you please let me know who can assist from your team?